Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NULLIF

The NULLIF function compares one expression with another and returns `NA` when the expressions are equal, or the base expression when they are not.

Return Value

`NA` when the expressions are equal, or the base expression when they are not.

Syntax

NULLIF (expr1 , expr2)

Arguments

expr1

  An expression. The base expression for the comparison

expr2

  An expression to compare to expr1.